package com.itheima.mapper;

import com.itheima.pojo.KsClass;
import com.itheima.pojo.User;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface LoginMapper {


    @Select("select role_id from ssm_db.user where mobile =#{mobile}")
    Integer findUserRoleIdByMobile(String mobile);

    List<KsClass> findClass(String mobile,Integer role);

    @Select("select id from ssm_db.user where mobile = #{mobile} and password = #{password}")
    User findUserByClassIdMobilePassword(@Param("mobile") String mobile, @Param("password") String password);
//    @Param("classId") Integer classId,


}
